147

Advanced Graphics

147

OptionButton2

OptionButton1

TextBox1

OptionButton4

OptionButton3

CommandButton1

FIGURE 11.11  Form fields.

Step 2

Set up the sheets that you need to do the data manipulation. There are three sheets

required:

• “Any State” which stores the data with dates in each row and states across

the columns

FIGURE 11.12  Any State.

• “States” that will store the state-​level statistics

FIGURE 11.13  State-​level statistics.

• “Graphs” that will be used as the palette to show the charts we need as well

as the US map.